A pivot table is a tool that allows you to present data from an ordinary flat table in a form that is easy to analyze.

Pivot tables allow you:

•To quickly place data from the source table columns into the pivot table columns and rows and swap them around.

•To perform calculations.

•To filter data.